package cn.cloud.butler.scheduled.repository;

import cn.cloud.butler.scheduled.domain.ArchivesEntity;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;


import java.util.List;

public interface ArchivesRepository extends JpaRepository<ArchivesEntity, Long> {


    @Query(value = "select DISTINCT t.MacSN from Archives t where t.MacSN != '' ",nativeQuery = true)
    List<String> findAllMacSN();
    @Query(value = "select DISTINCT TRIM(MacSN) from Archives",nativeQuery = true)
    List<String> findAllMacsn();

}
